using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using SqlSugar;
using System.Linq.Expressions;
using System.Threading.Tasks;


#region Mantis Code Auto Generate Assistant Illustration V1.0
/// AutoCode 代码生成助手 V1.2
/// 数据库版本 MySQL 5.7.18
/// 设计依据：App.Config所在的MySQL的表格 ProductionDetailsInfo
/// ********************************************************************
/// <summary>
/// 设计表格默认包含的字段如下：
/// id 主键 int 
/// 表格名称命名规则是小写字母单次，不同单词用下划线连接
/// 字段名称命名规则是小写字母单次，不同单词用下划线连接
/// is_enabled 删除标识 int[ -1 彻底删除][ 0 删除][ 1 有效 ] 
/// 用户登录的函数，关联一个用户登录日志表：user_login(id,user_id,login_time,logout_time),否则log必须为false
/// 时间类型的数据数据库中如果用bigint表达，必须包含 date 或者 time 才能被识别，会自动生成datetime数据
/// 非引用类对象，数字，字符，布尔等类型考虑到数据库，可能为空的情况，如果支持null类型，声明为：类型?
/// 非引用类对象，数字，字符，布尔等类型考虑到数据库，可能为空的情况，如果不支持null类型，声明为：类型
/// 非引用类对象，数字，字符，布尔等类型，如果不支持null类型，在自动转换时候数字会转换为0 字符为 '' 布尔为false
/// 对于数字主键，0是C#中的默认值，故要求数据库中不存在主键值为0的情况
/// 字段和属性为一一对应，属性为简单属性结构，属性Get,Set方法都是public，且未添加其他判断内容
/// 代码生成时间：2024年10月-17日 07时30分
/// <summary>
#endregion


namespace AccessibilityTools.DB
{
    /// <summary>
    /// public class SugarColumn : Attribute  注意点引用sqlsugar库，声明[SugarTable("production_details_info")]表名，然后写对应的表结构数据
    /// 比如 [SqlSugar.SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true, IsNullable = false)]引用id方法来定义表中的id
    /// 需要注意的是要求列名要和数据库创建的数据名字一致要不使用特性引用不到
    /// </summary>
    [SugarTable("production_details_info")]
    public class ProductionDetailsInfo : BaseEntity
    {

        #region Property[6]
        /// 
        ///id
        /// IsNullable
        //[DataGridViewSetting("id" , IsDisplayed = true)]分别表示ColumnName = "id" IsPrimaryKey是否为主键，IsIdentity独立身份，IsNullable可否为空
        [SqlSugar.SugarColumn(ColumnName = "id", IsPrimaryKey = true, IsIdentity = true, IsNullable = false)]
        public int Id { set; get; }

        /// 
        ///product_types  sn码
        /// 
        //[DataGridViewSetting("product_name" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "production_types", ColumnDataType = "varchar", Length = 200, IsNullable = true)]
        public string ProductTypes { set; get; }

        /// 
        /// production_length
        /// 
        //[DataGridViewSetting(" production_length" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "production_length", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Production_Length { set; get; }
        /// 
        /// large_outer_diameter 大外径
        /// 
        //[DataGridViewSetting(" large_outer_diameter" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "large_outer_diameter", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Large_Outer_Diameter { set; get; }
        /// 
        /// small_outer_diameter  小外径
        /// 
        //[DataGridViewSetting(" small_outer_diameter" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "small_outer_diameter", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Small_Outer_Diameter { set; get; }
        /// 
        ///bottom_cover_value 底盖外径
        /// 
        //[DataGridViewSetting("bottom_cover_value" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "bottom_cover_value", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Bottom_Cover_Value { set; get; }
        /// 
        ///production_height  产品高度
        /// 
        //[DataGridViewSetting("production_height" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "production_height", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Production_Height { set; get; }

        /// 
        /// displacement_value  位移值
        /// 
        //[DataGridViewSetting(" displacement_value" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "displacement_value", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Displacement_Value { set; get; }

        /// 
        /// pressure_limmit_value  压力极限值
        /// 
        //[DataGridViewSetting(" pressure_limmit_value" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "pressure_limmit_value", ColumnDataType = "double", Length = 255, IsNullable = true)]
        public double Pressure_Limmit_Value { set; get; }

        /// 
        ///is_deleted
        /// 
        //[DataGridViewSetting("is_deleted" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "is_deleted", ColumnDataType = "tinyint", IsNullable = true)]
        public new Int16 IsDeleted { set; get; }

        /// 
        ///creation_time
        /// 
        //[DataGridViewSetting("creation_time" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "creation_time", ColumnDataType = "datetime", IsNullable = true)]
        public DateTime CreationTime { set; get; }

        /// 
        ///qr_code  二维码
        /// 
        //[DataGridViewSetting("qr_code" , IsDisplayed = true)]
        [SqlSugar.SugarColumn(ColumnName = "qr_code", ColumnDataType = "varchar", Length = 255, IsNullable = true)]
        public string Qr_Code { set; get; }

        #endregion



    }
}
